package com.ruoyi.report_sj.mapper;

import com.ruoyi.report_sj.domain.ReportSjbhwxnsyBaDetail;
import com.ruoyi.report_sj.domain.vo.ReportSjbhwxnsyBaDetailVo;
import com.ruoyi.common.core.mapper.BaseMapperPlus;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 砂浆拌合物性能试验检测记录详情Mapper接口
 *
 * @author zyb
 * @date 2024-05-29
 */
public interface ReportSjbhwxnsyBaDetailMapper extends BaseMapperPlus<ReportSjbhwxnsyBaDetailMapper, ReportSjbhwxnsyBaDetail, ReportSjbhwxnsyBaDetailVo> {

    @Select("select * from report_sjbhwxnsy_ba_detail where excel_id = #{excelId} and del_flag = 0")
    List<ReportSjbhwxnsyBaDetail> selectListByExcelId(Long excelId);

    @Delete("delete from report_sjbhwxnsy_ba_detail where excel_id = #{excelId}")
    void deleteByExcelId(Long excelId);
}
